<?xml version="1.0" encoding="utf-8" ?>
<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
  <connectionStrings>
    <add name="CRM" connectionString="Url=https://sustainalytics.crm4.dynamics.com;Username=client.platform@sustainalytics.com;Password=M46iaHerm3s21!" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="ValidationRules" connectionString="mongodb://10.11.7.141:27017/Validation" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="GAMongoDBConnectionString" connectionString="mongodb://10.11.7.141:27017" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="DSOMongoDBConnectionString" connectionString="mongodb://10.0.1.15:27017" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="MongoDBConnectionString" connectionString="mongodb://sustadmin:G4nd4lf2014@10.11.7.141:27017" xdt:Transform="InsertIfMissing" xdt:Locator="Match(name)" />
    <add name="ClientPlatform" connectionString="mongodb://sustadmin:G4nd4lf2014@10.11.7.141:27017/ClientPlatform" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="RPHistoricalDataSet" connectionString="mongodb://sustadmin:G4nd4lf2014@10.11.7.141:27017/RPHistoricalDataSet" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="ClientDWMaster" connectionString="mongodb://sustadmin:G4nd4lf2014@10.11.7.141:27017/ClientDWMaster" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="RPConnectionString" connectionString="Data Source=sust-live-app-srv.cloudapp.net,51433;User ID=sql_server_admin;Password=H0bb1t2014;Initial Catalog=DSRSystem;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="RPConnectionString_Temp" connectionString="Data Source=sust-live-app-srv.cloudapp.net,51433;User ID=sql_server_admin;Password=H0bb1t2014;Initial Catalog=DSRSystem_temp;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="EventsConnectionString" connectionString="Data Source=news-data-srv.westeurope.cloudapp.azure.com;User ID=sql_server_admin;Password=H0bb1t2014;Initial Catalog=Live_Events_Temp;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="GCCSConnectionString" connectionString="Data Source=news-data-srv.westeurope.cloudapp.azure.com;User ID=sql_server_admin;Password=H0bb1t2014;Initial Catalog=Live_GCCS;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="GovernanceConnectionString" connectionString="Data Source=gov-sqlsrv-01.cloudapp.net,51433;User ID=sql_server_admin;Password=H0bb1t2014;Initial Catalog=DSRSystem_Temp;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="GovernanceInputFile" connectionString="mongodb://sustadmin:G4nd4lf2014@10.11.7.141:27017/GovernanceInputFile" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="CarbonDataConnectionString" connectionString="Data Source=news-data-srv.westeurope.cloudapp.azure.com;User ID=sql_reader;Password=Sl070066!;Initial Catalog=CARBON;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="PIConnectionString" connectionString="Data Source=news-data-srv.westeurope.cloudapp.azure.com;User ID=sql_pi;Password=S@ur0n_2017!;Initial Catalog=PI;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="ActiveMQ" connectionString="activemq:tcp://activemq.live.sust-aws.local:61616" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="ActiveMQTopic" connectionString="Synchronization.Topic.Stage" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="ActiveMQQueue" connectionString="queue://ConnectionStringsQueueStage" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
  </connectionStrings>
  <appSettings>
    <add key="Steps" value="SyncCorporateData, SyncHbaseData, SyncReferenceUniverses, UniversesFromCrm, LoadFeatureUniverses, CompanyWeights, SyncEsgData, SyncControversies, SyncGlobalCompact, SyncProductInvolvement, SyncGovernance, SyncGovernanceComputation, SyncRiskRatingsData, SyncRiskRatingsBenchmarks, ESGRatingsDataValidation, CarbonData, PITraditional, PISolutions, ReportDataPreparation, FocusedRatingsComputationOutput2, ControversyAlerts, DataValidation, AssureFeatureUniverses,SyncHistoricalData, SyncSecuritiesLists, ScreeningData, PregenerateScreeningReports, CleanupS3, GeneratePDFReports, ProcessedFiles" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="SyncRefUnivFilePath" value="c:\sustainalytics\syncrefuniv.csv" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="RedisServer" value="Stage-Redis" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="DumpComputationResults" value="true" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="executehistorical" value="false" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="PSR_TTLMinutes" value="240" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="PSR_MainMachine" 	value="i-0be8171bdd87dac59" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="PSR_Machines" 	value="i-0be8171bdd87dac59,i-0ae7d138765249f99" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="s3bucket" value="stage-globalaccess-europe" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="SkipClonning" value="false" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="PDFPath" value="p:\companypdf" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="IsSyncAutomatic" value="True" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="GeneratePartialControveryReports" value="False" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="pdfservurl" value="http://10.11.5.237/pdfgenerationserv/" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="InitialRecurringDate" value="09/01/2016 06:00:00" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="RegularRepeatInterval" value="1:00:00:00" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="ComputationServiceAddress" value="http://10.11.6.254:10280/esgcomputingserv/api/v1" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="GovernanceServiceAddress" value="http://10.11.6.254:10280/governanceserv/api/v1/reportsgeneration" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="DefaultCloudCluster" value="aws" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="templateImage" value="ami-32d99845" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="mainCudaInstanceId" value="i-bd353c5b" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="awMachineCountAvailable" value="1" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="machineDemand" value="1" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="awsSubnetId" value="subnet-d253928b" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="awsSecGroupId" value="sg-cfdb4caa" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="awsMachineTag" value="GAP-STAGE" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="PDF_MachineId" value="i-0af2ef0cc42830fa4" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="RedisConnectionString" value="Stage-Redis" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="DeploymentLocation" value="STAGE" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HostUrl" value="http://+:10280/clientsync" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="clientPlatformUrl" value="https://52.18.50.126:80" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="ReplicaSetName" value="gapStage" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HBaseUrl" value="canvastaging.westeurope.cloudapp.azure.com" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HBaseThriftServer" value="canvastaging.westeurope.cloudapp.azure.com" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HiveConnectionString" value="DRIVER={Hortonworks Hive ODBC Driver};Host=cddbloadbalancer.westeurope.cloudapp.azure.com;Port=10000;Schema=cddb;HiveServerType=2" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HBaseTablePrefix" value="stage_" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HBasePrefix" value="stage_" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="PhoenixServerUrl" value="canvastaging.westeurope.cloudapp.azure.com" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="PhoenixVnetMode" value="true" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="PhoenixPassword" value="Cddbase2015!" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="SyncDsoDatabase" value="true" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="performProfileRestore" value="false" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key ="CartePath" value="http://10.11.6.254:8081/kettle/executeJob/?job=D:/PDI/jobs/portfolio_analytics/fullPaDBSync.kjb" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="CarteMessage" value="" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="CarteParameter" value="" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
  </appSettings>
</configuration>
